UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDTeFoNPOacqvPWX4ti6iIGkydnkb/itFkdIumd6cmY='
WHERE
key_id = 'e30d658760ba0ff4a8490ebaf0636d032b8e734bdb9300a0d0d9a0f42e5be6ed'
AND (
token = 'xDTeFoNPOacqvPWX4ti6iIGkydnkb/itFkdIumd6cmY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)