UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pmuALYYQjKnrO9pBWlV6iaREP6LmN4qv90d5LnrnVs='
WHERE
key_id = '729b7e9651842fa14edbe0cd6c18f4fda38505f0184d078d25fc16c71e6563ab'
AND (
token = '8pmuALYYQjKnrO9pBWlV6iaREP6LmN4qv90d5LnrnVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)