UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'EhzsUWHT1qcU5YPXkzyKiCSD+ena7HtT5TPVQ4IPHRE='
WHERE
key_id = 'c498e041d76371eb8c7d99ea4ceb46b4405ff8d55d91fae997d7a99a3244f2a2'
AND (
token = 'EhzsUWHT1qcU5YPXkzyKiCSD+ena7HtT5TPVQ4IPHRE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)