UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3LcdgXgeXWF7DVLwjbYjc2QIswmR8luxFy8J6tdojKY='
WHERE
key_id = '12602b9f0f900bcd741e6d7f82f98fc73a3909204462e4091ee2bf04a29b9771'
AND (
token = '3LcdgXgeXWF7DVLwjbYjc2QIswmR8luxFy8J6tdojKY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)