UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H8UgvgZkAwX5YVcd05+FHGiE9mpE1+IGP5vDTfNMCms='
WHERE
key_id = 'c6c0aae13798dec2f78a0208028e6b1904ffc17a4f02ee1bee530e41dfa37aad'
AND (
token = 'H8UgvgZkAwX5YVcd05+FHGiE9mpE1+IGP5vDTfNMCms='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)