UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jW7NJdvQJ5JAsMf/MLGv0p+bemPXS9LeHE5Q/aMiwvY='
WHERE
key_id = 'a20ebf102f426018ba6be68b5e98e4cdc296bd6014adfd249f5f7f91fd56d15f'
AND (
token = 'jW7NJdvQJ5JAsMf/MLGv0p+bemPXS9LeHE5Q/aMiwvY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)