UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pk/gdnylnZl9tdRU/ha0nVQd7/AzTWhO4TDtRSEeUKM='
WHERE
key_id = 'ad4dca6fdb8caa38bf6d127b5a333b99dc92c23191fea0402b88dd72be908aaf'
AND (
token = 'pk/gdnylnZl9tdRU/ha0nVQd7/AzTWhO4TDtRSEeUKM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)