UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Qyz57LRr87i8bD16rd7anrd4I2tO47Wut4ojOjyHTxQ='
WHERE
key_id = '3794961876124ea9bc15b68ba86f6db9febe7520b2f7f9226fdd01f3ef426615'
AND (
token = 'Qyz57LRr87i8bD16rd7anrd4I2tO47Wut4ojOjyHTxQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)