UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nhvQ4ZJvIsflbVDH/mqtqJlWnq6WvrBY/iDkaxFhrpw='
WHERE
key_id = 'e7cbe7053e493a7d5802e6b6c13ded48f109f50997b476f7eac3af52ab169e14'
AND (
token = 'nhvQ4ZJvIsflbVDH/mqtqJlWnq6WvrBY/iDkaxFhrpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)