UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KkBZuFHQq5mhewegArTedbXOWhFxXyIB/jZl6WFMwU='
WHERE
key_id = 'e79dbe234d2e6cfb45566d132bb01332b4b2e65f87434fc1b854b04c6d54dec4'
AND (
token = '/KkBZuFHQq5mhewegArTedbXOWhFxXyIB/jZl6WFMwU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)