UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nw2HC9kBct5Vjy0GluRJGFCV2rLA+N2V6SJwO6EXLXo='
WHERE
key_id = '3ec0498b6da8aa50ffe7c6e3312301f04f48e8eb56711289148d86161261696f'
AND (
token = 'nw2HC9kBct5Vjy0GluRJGFCV2rLA+N2V6SJwO6EXLXo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)