UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pX5p+bpjYfqFy88CzJ415EPWI01CAbsMvJ2A55GrQpw='
WHERE
key_id = 'c5aae09d71ab0891f6aee5f01beb5b6e00eeb5ac256e5c326524a226e6d7f09b'
AND (
token = 'pX5p+bpjYfqFy88CzJ415EPWI01CAbsMvJ2A55GrQpw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)