UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hRA8wakER/mLU/TCC9kYmVueh2xxsjdyfud5D6UsH0w='
WHERE
key_id = '9fa2ef115f4e23355dc0eaeca138cb4ad2f1fcc13d8913833b4fa8e866751e59'
AND (
token = 'hRA8wakER/mLU/TCC9kYmVueh2xxsjdyfud5D6UsH0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)