UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'km0H4RackW/B6S6aGFgeo9FWJlXKzMumSsV46uHd5Uc='
WHERE
key_id = '4e01e64bb567273c225572b5c1b2f33fe460ff0372fe7bf4949f3d9991fb9cba'
AND (
token = 'km0H4RackW/B6S6aGFgeo9FWJlXKzMumSsV46uHd5Uc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)