UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NzNLXFn8uRrpFwDrNk5PFn+NW3dpmsaeqt/0E/tHHPc='
WHERE
key_id = '47edf12d7ee986eff27ea246e654b49caf54ff3f1c53a7ff917c5475df328fbb'
AND (
token = 'NzNLXFn8uRrpFwDrNk5PFn+NW3dpmsaeqt/0E/tHHPc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)