UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '/Ej7OFXTfaLAWgqXIQ6IDfTC90GufDLCwICCP97q0Eg=' 
WHERE 
  key_id = '5f5ca5f81cda94044f1d31f9c243ca03c3b9bc5ce37d9d6d8f0201bc91fdc34f' 
  AND (
    token = '/Ej7OFXTfaLAWgqXIQ6IDfTC90GufDLCwICCP97q0Eg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023