UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LygtpAU/W+6LGlZq+cw2rY+jnlAxx689oe8bzXswjfU='
WHERE
key_id = 'aa4e5bcd023116dff05f09947b0564560ce8a47310f00e50a7c49b227e4f31b8'
AND (
token = 'LygtpAU/W+6LGlZq+cw2rY+jnlAxx689oe8bzXswjfU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)