UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JgStTy4Q8QFI9s46NNO5qORGb1BR4W0kkFR+1EVlXT4='
WHERE
key_id = 'e059a789f90b9b6721e49a7d96332d914db0e083adba4bb7b7819e882da7b55d'
AND (
token = 'JgStTy4Q8QFI9s46NNO5qORGb1BR4W0kkFR+1EVlXT4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)