UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5wQ7cQ05P4G0mPgI8rXK3gttje16RNoJRc1SZzCOovA='
WHERE
key_id = '8172316f51f1bc1081abb4ca9b833324b0f46f36b58669719c7a9c588580be0f'
AND (
token = '5wQ7cQ05P4G0mPgI8rXK3gttje16RNoJRc1SZzCOovA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)