UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HjroTaoFXYm0WEyK39qUU9aKSJ/G9Mj+/rgidQAutBE='
WHERE
key_id = '78447d76e3e9794ef6c9352cb0aba6aa06c20f48d40489ddc2481cd2f8731e1a'
AND (
token = 'HjroTaoFXYm0WEyK39qUU9aKSJ/G9Mj+/rgidQAutBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)