UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ftMv4JA/lkKUwLOs8Btp8xKg1KH2E4Mq+gVazVa0Y4w='
WHERE
key_id = 'c59d214c5450a29ec977a93fda2bf10f9de3330f43dd149f91547a15cd0ca80a'
AND (
token = 'ftMv4JA/lkKUwLOs8Btp8xKg1KH2E4Mq+gVazVa0Y4w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)