UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Dk6nR0DWsDeEIe9U77nP46+QLlsPacNvlqkePzVg6XM='
WHERE
key_id = 'aac420ceee54b03e3097d845b5c5abf42352c406ed114e9a26ec29b1cb40ebe6'
AND (
token = 'Dk6nR0DWsDeEIe9U77nP46+QLlsPacNvlqkePzVg6XM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)