UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vGKFruXfOYq0y/gB3qf7L3B3VExA6Qvg7yCNygzt8hE='
WHERE
key_id = 'e2cb81939a3fac14ec857d31a120e5b95f5672ab822e10ed64b48b294acc1a09'
AND (
token = 'vGKFruXfOYq0y/gB3qf7L3B3VExA6Qvg7yCNygzt8hE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)