UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZIjKe3zkA1vUpB4nIbRU5cuUSceNnEIwSBvsklRXAZ0='
WHERE
key_id = 'c099ce35d36be748cca856ba9213b0769a53582479f8c9175700134635430e39'
AND (
token = 'ZIjKe3zkA1vUpB4nIbRU5cuUSceNnEIwSBvsklRXAZ0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)