UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ng6eK8iidI4OD1572USCQZ6t0b0AA0BEeLTjVjX+6Pk='
WHERE
key_id = '22a7e3b8b097209f0c14bb434627f8e62faf15df18125f018f6284e8385e5413'
AND (
token = 'ng6eK8iidI4OD1572USCQZ6t0b0AA0BEeLTjVjX+6Pk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)