UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ptLqb7zEv7C2ugeeXUxtUVC8KW1iB4O2vYfV6d9Aoxw='
WHERE
key_id = '29b99a48d43162ea081ad2005bd6ee49ecb991997134acc38ce8c73cc5e19ab7'
AND (
token = 'ptLqb7zEv7C2ugeeXUxtUVC8KW1iB4O2vYfV6d9Aoxw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)