UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/fkUcSAl7As1f91VnfXQX5AUG9yLK3d7/2jrmXgWmoo='
WHERE
key_id = '289ea07ef7f2d284495b1a7f8f2ef3e446e863cfbe08598880224c06b6847c3b'
AND (
token = '/fkUcSAl7As1f91VnfXQX5AUG9yLK3d7/2jrmXgWmoo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)