UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XqTPVdFUkw2o8y7BPXIpBecgFzzYwZkS19FbzatD6eg='
WHERE
key_id = '69e7e198d00af9385ba9a13e4c39047dfd10af6078766c8be30e59c7df7ba1d4'
AND (
token = 'XqTPVdFUkw2o8y7BPXIpBecgFzzYwZkS19FbzatD6eg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)