UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qoRCummU31l/5MjEpAkgrQetzbMRty7pwqTJ/TUw5Sw='
WHERE
key_id = 'a7ddf65253b1a7e46ac2a40d639d6252b488de89b1bde3bf6b819442d3b7a012'
AND (
token = 'qoRCummU31l/5MjEpAkgrQetzbMRty7pwqTJ/TUw5Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)