UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CItOp4BlO9o4KOwn9zqKpeeLbALEOAKMa8dyQw23Bq4='
WHERE
key_id = 'e0e70d6486b752120aabf4e9d6df744a200038b1aff3c30cbc1b92c32270bc01'
AND (
token = 'CItOp4BlO9o4KOwn9zqKpeeLbALEOAKMa8dyQw23Bq4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)