UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qlQjp2bfmOneWuktI6YHkkhKWjBwNYxuHHGNqU6xEXs='
WHERE
key_id = 'a9084192dd4108f40ab73854c7043f0bba21c4b5f9c204b21463ed133d071ab6'
AND (
token = 'qlQjp2bfmOneWuktI6YHkkhKWjBwNYxuHHGNqU6xEXs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)