UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'S7zBtiZ4R9BHlTyxe2FZLFP/RDruhM+5TaC2R4SSo30='
WHERE
key_id = '9e177cb1b8d906383cdc8eec9f06a689a7faf6afd3c94db8b5f7fe3b4cab81b0'
AND (
token = 'S7zBtiZ4R9BHlTyxe2FZLFP/RDruhM+5TaC2R4SSo30='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)