UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NnEPsj0REA1WfkqWIwv/3nn4qTWhLO9gTxivGykjYxA='
WHERE
key_id = '767940058e4f598170036a4e0cbef0276e2020c5c457d839ee3354cbfff357f5'
AND (
token = 'NnEPsj0REA1WfkqWIwv/3nn4qTWhLO9gTxivGykjYxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)