UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'tWyJ9udEZzE/ZwY1xf7iHfMDwC23xa7L8ovNFU5e02Q=' 
WHERE 
  key_id = '4263a016e4fa46cbacbf4df35f8a49b56337500b812f098d6e12ff4ccfc0b80f' 
  AND (
    token = 'tWyJ9udEZzE/ZwY1xf7iHfMDwC23xa7L8ovNFU5e02Q=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00035